Adding SQL Server

When you access the user interface for the first time the workspace is empty and after changing your password and updating your profile with your preferences, the next step would be to add one or more SQL Servers to the workspace so that you can start generating your feeds.

To add a SQL Server click on the “+ New SQL Server” on the top right corner of the left panel and a “New SQL Server” tab will appear on the main panel of the page. In most cases you will only need to provide the full name of the SQL Server instance you wish to connect to as well as the username and password. However, RSS Reporter allows you to specify the following settings as well:

Connection Timeout: indicates the amount of time, in seconds, that a SQL Server operation waits to establish a connection before aborting the attempt and generating an error.
Command Timeout: indicates the wait time, in seconds, to complete a SQL Server operation before aborting the attempt and generating an error.
Network Packet Size: indicates the size, in bytes, of the network packets to communicate with SQL Server.
Protocol: indicates the protocol, which determines the network library that will be used to communicate with the SQL Server.
Other connection settings: other connection settings that you might require. Specify them as “name=value” separated by semicolons.

Once you have provided the connection information click on the “Read Databases” link in the “Databases Section”. RSS Reporter will attempt to connect to the specified SQL Server instance and read the user databases. If the connection is successful and the credentials you have provided have sufficient permissions the “Databases” box will be populated with the complete list of databases in that SQL Server instance.

By default all databases will be “checked” meaning that they will be registered to the workspace. However, you can click on “Clear All” to deselect all databases and then manually select only those databases you want to include.

Once you are done with your selection click on the “add” button at the bottom and you will see the SQL Server and the selected databases appear on the left panel. You are now ready to start generating atom / rss feeds with information from this server / databases.